Dataset info
| Number of variables | 53 |
|---|---|
| Number of observations | 19498 |
| Missing cells | 6709 (0.6%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 7.9 MiB |
| Average record size in memory | 424.0 B |
Variables types
| Numeric | 9 |
|---|---|
| Categorical | 34 |
| Boolean | 5 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 5 |
| Unsupported | 0 |
Warnings
Account_Created_Date has a high cardinality: 903 distinct values | Warning |
Account_Name has a high cardinality: 1840 distinct values | Warning |
Actual_Delivery_Date has constant value "NaT" | Rejected |
ASP has 316 (1.6%) zeros | Zeros |
ASP has 3293 (16.9%) missing values | Missing |
ASP_(converted) is highly skewed (γ1 = 74.73154913) | Skewed |
ASP_(converted) has 315 (1.6%) zeros | Zeros |
ASP_(converted) has 3293 (16.9%) missing values | Missing |
ASP_(converted)_Currency has constant value "USD" | Rejected |
Billing_Country has a high cardinality: 83 distinct values | Warning |
Last_Activity has constant value "NaT" | Rejected |
Last_Modified_By has a high cardinality: 63 distinct values | Warning |
Last_Modified_Date has a high cardinality: 751 distinct values | Warning |
Month has a high cardinality: 60 distinct values | Warning |
Opportunity_Created_Date has a high cardinality: 1203 distinct values | Warning |
Opportunity_Name has a high cardinality: 11408 distinct values | Warning |
Opportunity_Owner has a high cardinality: 58 distinct values | Warning |
Planned_Delivery_End_Date has a high cardinality: 1214 distinct values | Warning |
Planned_Delivery_Start_Date has a high cardinality: 1193 distinct values | Warning |
Price has a high cardinality: 58 distinct values | Warning |
Prod_Category_A has constant value "Prod_Category_A_None" | Rejected |
Product_Family has a high cardinality: 247 distinct values | Warning |
Product_Name has a high cardinality: 506 distinct values | Warning |
Quote_Expiry_Date has a high cardinality: 1124 distinct values | Warning |
Sales_Contract_No has a high cardinality: 6065 distinct values | Warning |
Territory has a high cardinality: 79 distinct values | Warning |
Total_Amount is highly skewed (γ1 = 40.71457842) | Skewed |
Total_Amount_Currency is a recoding of ASP_Currency | Rejected |
Total_Taxable_Amount is highly skewed (γ1 = 30.86984245) | Skewed |
Total_Taxable_Amount has 1090 (5.6%) zeros | Zeros |
TRF is highly skewed (γ1 = 38.14278497) | Skewed |
TRF has 13677 (70.1%) zeros | Zeros |
Account_Created_Date
Categorical
| Distinct count | 903 |
|---|---|
| Unique (%) | 4.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 7/27/2013 | |
|---|---|
| 4/20/2015 | |
| 9/23/2013 | 610 |
| Other values (900) |
| Value | Count | Frequency (%) | |
| 7/27/2013 | 3061 | 15.7% | |
| 4/20/2015 | 3014 | 15.5% | |
| 9/23/2013 | 610 | 3.1% | |
| 9/19/2014 | 397 | 2.0% | |
| 12/21/2015 | 365 | 1.9% | |
| 8/22/2013 | 327 | 1.7% | |
| 7/28/2013 | 307 | 1.6% | |
| 10/3/2013 | 276 | 1.4% | |
| 9/28/2016 | 236 | 1.2% | |
| 1/29/2016 | 215 | 1.1% | |
| Other values (893) | 10690 | 54.8% |
| Max length | 10 |
|---|---|
| Mean length | 8.964355318 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Account_Name
Categorical
| Distinct count | 1840 |
|---|---|
| Unique (%) | 9.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Account_Name_1888 | 2127 |
|---|---|
| Account_Name_1836 | 886 |
| Account_Name_25 | 873 |
| Other values (1837) |
| Value | Count | Frequency (%) | |
| Account_Name_1888 | 2127 | 10.9% | |
| Account_Name_1836 | 886 | 4.5% | |
| Account_Name_25 | 873 | 4.5% | |
| Account_Name_1991 | 609 | 3.1% | |
| Account_Name_1642 | 397 | 2.0% | |
| Account_Name_1508 | 365 | 1.9% | |
| Account_Name_1440 | 318 | 1.6% | |
| Account_Name_533 | 313 | 1.6% | |
| Account_Name_263 | 270 | 1.4% | |
| Account_Name_660 | 231 | 1.2% | |
| Other values (1830) | 13109 | 67.2% |
| Max length | 17 |
|---|---|
| Mean length | 16.49825623 |
| Min length | 14 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Account_Owner
Categorical
| Distinct count | 48 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_50 | |
|---|---|
| Person_Name_8 | 1532 |
| Person_Name_13 | 1497 |
| Other values (45) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3795 | 19.5% | |
| Person_Name_8 | 1532 | 7.9% | |
| Person_Name_13 | 1497 | 7.7% | |
| Person_Name_43 | 1451 | 7.4% | |
| Person_Name_18 | 1289 | 6.6% | |
| Person_Name_3 | 966 | 5.0% | |
| Person_Name_64 | 839 | 4.3% | |
| Person_Name_4 | 747 | 3.8% | |
| Person_Name_32 | 729 | 3.7% | |
| Person_Name_65 | 719 | 3.7% | |
| Other values (38) | 5934 | 30.4% |
| Max length | 14 |
|---|---|
| Mean length | 13.79310699 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Account_Type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Account_Type_2 | |
|---|---|
| Account_Type_0 | |
| Account_Type_5 | |
| Other values (4) | 316 |
| Value | Count | Frequency (%) | |
| Account_Type_2 | 9989 | 51.2% | |
| Account_Type_0 | 6993 | 35.9% | |
| Account_Type_5 | 2200 | 11.3% | |
| Account_Type_1 | 167 | 0.9% | |
| None | 113 | 0.6% | |
| Account_Type_4 | 19 | 0.1% | |
| Account_Type_6 | 17 | 0.1% |
| Max length | 14 |
|---|---|
| Mean length | 13.94204534 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Actual_Delivery_Date
Constant
This variable is constant and should be ignored for analysis
| Constant value | NaT |
|---|
ASP
Numeric
| Distinct count | 319 |
|---|---|
| Unique (%) | 1.6% |
| Missing (%) | 16.9% |
| Missing (n) | 3293 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.328521031 |
|---|---|
| Minimum | 0 |
| Maximum | 80 |
| Zeros (%) | 1.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.25 |
| Q1 | 0.35 |
| Median | 0.395 |
| Q3 | 0.49 |
| 95-th percentile | 55 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range | 0.14 |
Descriptive statistics
| Standard deviation | 17.79904956 |
|---|---|
| Coef of variation | 2.812513298 |
| Kurtosis | 6.369409575 |
| Mean | 6.328521031 |
| MAD | 10.63439147 |
| Skewness | 2.811422481 |
| Sum | 102553.6833 |
| Variance | 316.8061651 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 0.38 | 847 | 4.3% | |
| 0.4 | 836 | 4.3% | |
| 0.36 | 762 | 3.9% | |
| 0.42 | 558 | 2.9% | |
| 0.39 | 498 | 2.6% | |
| 0.37 | 445 | 2.3% | |
| 0.35 | 328 | 1.7% | |
| 0.34 | 319 | 1.6% | |
| 0 | 316 | 1.6% | |
| 0.365 | 283 | 1.5% | |
| Other values (308) | 11013 | 56.5% | |
| (Missing) | 3293 | 16.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 316 | 1.6% | |
| 1e-05 | 1 | < 0.1% | |
| 0.13 | 23 | 0.1% | |
| 0.15 | 56 | 0.3% | |
| 0.155 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 80 | 14 | 0.1% | |
| 78 | 86 | 0.4% | |
| 77 | 12 | 0.1% | |
| 76 | 6 | < 0.1% | |
| 75 | 99 | 0.5% |
ASP_(converted)
Numeric
| Distinct count | 464 |
|---|---|
| Unique (%) | 2.4% |
| Missing (%) | 16.9% |
| Missing (n) | 3293 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4235557655 |
|---|---|
| Minimum | 0 |
| Maximum | 67 |
| Zeros (%) | 1.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.27 |
| Q1 | 0.36 |
| Median | 0.40154 |
| Q3 | 0.46375 |
| 95-th percentile | 0.62 |
| Maximum | 67 |
| Range | 67 |
| Interquartile range | 0.10375 |
Descriptive statistics
| Standard deviation | 0.7679097921 |
|---|---|
| Coef of variation | 1.81300753 |
| Kurtosis | 5861.978161 |
| Mean | 0.4235557655 |
| MAD | 0.09128992887 |
| Skewness | 74.73154913 |
| Sum | 6863.72118 |
| Variance | 0.5896854489 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 0.4 | 621 | 3.2% | |
| 0.38 | 610 | 3.1% | |
| 0.36 | 521 | 2.7% | |
| 0.39 | 355 | 1.8% | |
| 0.42 | 342 | 1.8% | |
| 0 | 315 | 1.6% | |
| 0.37 | 244 | 1.3% | |
| 0.40719 | 237 | 1.2% | |
| 0.42982 | 236 | 1.2% | |
| 0.47506 | 216 | 1.1% | |
| Other values (453) | 12508 | 64.2% | |
| (Missing) | 3293 | 16.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 315 | 1.6% | |
| 1e-05 | 1 | < 0.1% | |
| 0.00378 | 1 | < 0.1% | |
| 0.13 | 23 | 0.1% | |
| 0.15 | 56 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 67 | 1 | < 0.1% | |
| 57.68578 | 1 | < 0.1% | |
| 40.71938 | 1 | < 0.1% | |
| 1.7 | 1 | < 0.1% | |
| 1.6 | 6 | < 0.1% |
ASP_(converted)_Currency
Constant
This variable is constant and should be ignored for analysis
| Constant value | USD |
|---|
ASP_Currency
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| USD | |
|---|---|
| EUR | |
| JPY | |
| Other values (2) | 561 |
| Value | Count | Frequency (%) | |
| USD | 8908 | 45.7% | |
| EUR | 5339 | 27.4% | |
| JPY | 4690 | 24.1% | |
| AUD | 556 | 2.9% | |
| GBP | 5 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Billing_Country
Categorical
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Japan | |
|---|---|
| United States | |
| Germany | |
| Other values (80) |
| Value | Count | Frequency (%) | |
| Japan | 5080 | 26.1% | |
| United States | 4800 | 24.6% | |
| Germany | 2272 | 11.7% | |
| Australia | 1359 | 7.0% | |
| India | 752 | 3.9% | |
| Netherlands | 649 | 3.3% | |
| France | 537 | 2.8% | |
| Singapore | 526 | 2.7% | |
| Spain | 372 | 1.9% | |
| Italy | 367 | 1.9% | |
| Other values (73) | 2784 | 14.3% |
| Max length | 42 |
|---|---|
| Mean length | 8.374243512 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Brand
Categorical
| Distinct count | 28 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 877 |
| Brand_9 | 153 |
| Other values (25) | 375 |
| Value | Count | Frequency (%) | |
| None | 18093 | 92.8% | |
| Other | 877 | 4.5% | |
| Brand_9 | 153 | 0.8% | |
| Brand_5 | 65 | 0.3% | |
| Brand_10 | 48 | 0.2% | |
| Brand_24 | 43 | 0.2% | |
| Brand_11 | 42 | 0.2% | |
| Brand_13 | 29 | 0.1% | |
| Brand_25 | 26 | 0.1% | |
| Brand_22 | 24 | 0.1% | |
| Other values (18) | 98 | 0.5% |
| Max length | 8 |
|---|---|
| Mean length | 4.140322084 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Bureaucratic_Code
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Bureaucratic_Code_4 | |
|---|---|
| Bureaucratic_Code_5 | |
| Bureaucratic_Code_2 | 351 |
| Other values (4) | 386 |
| Value | Count | Frequency (%) | |
| Bureaucratic_Code_4 | 14587 | 74.8% | |
| Bureaucratic_Code_5 | 4174 | 21.4% | |
| Bureaucratic_Code_2 | 351 | 1.8% | |
| Bureaucratic_Code_1 | 303 | 1.6% | |
| Bureaucratic_Code_0 | 80 | 0.4% | |
| Bureaucratic_Code_3 | 2 | < 0.1% | |
| Bureaucratic_Code_6 | 1 | < 0.1% |
| Max length | 19 |
|---|---|
| Mean length | 19 |
| Min length | 19 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Bureaucratic_Code_0_Approval
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 10416 | 53.4% | |
| 1 | 9082 | 46.6% |
Bureaucratic_Code_0_Approved
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 13443 | 68.9% | |
| 1 | 6055 | 31.1% |
Currency
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| USD | 631 |
| EUR | 615 |
| Value | Count | Frequency (%) | |
| None | 18252 | 93.6% | |
| USD | 631 | 3.2% | |
| EUR | 615 | 3.2% |
| Max length | 4 |
|---|---|
| Mean length | 3.93609601 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Quarter
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Q2 | |
|---|---|
| Q1 | |
| Q3 |
| Value | Count | Frequency (%) | |
| Q2 | 5511 | 28.3% | |
| Q1 | 5144 | 26.4% | |
| Q3 | 4455 | 22.8% | |
| Q4 | 4388 | 22.5% |
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Terms
Categorical
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Delivery_Terms_4 | |
|---|---|
| Delivery_Terms_2 | |
| Delivery_Terms_1 | |
| Other values (6) |
| Value | Count | Frequency (%) | |
| Delivery_Terms_4 | 8808 | 45.2% | |
| Delivery_Terms_2 | 5446 | 27.9% | |
| Delivery_Terms_1 | 3355 | 17.2% | |
| Delivery_Terms_6 | 928 | 4.8% | |
| Delivery_Terms_5 | 689 | 3.5% | |
| Delivery_Terms_8 | 172 | 0.9% | |
| Delivery_Terms_7 | 49 | 0.3% | |
| Delivery_Terms_3 | 42 | 0.2% | |
| Delivery_Terms_0 | 9 | < 0.1% |
| Max length | 16 |
|---|---|
| Mean length | 16 |
| Min length | 16 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Delivery_Year
Numeric
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2017.384911 |
|---|---|
| Minimum | 2016 |
| Maximum | 2020 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2016 |
|---|---|
| 5-th percentile | 2016 |
| Q1 | 2017 |
| Median | 2017 |
| Q3 | 2018 |
| 95-th percentile | 2019 |
| Maximum | 2020 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.004535054 |
|---|---|
| Coef of variation | 0.0004979392126 |
| Kurtosis | -0.9377144717 |
| Mean | 2017.384911 |
| MAD | 0.8703781513 |
| Skewness | 0.1603412073 |
| Sum | 39334971 |
| Variance | 1.009090675 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 2017 | 6318 | 32.4% | |
| 2018 | 5833 | 29.9% | |
| 2016 | 4371 | 22.4% | |
| 2019 | 2885 | 14.8% | |
| 2020 | 91 | 0.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2016 | 4371 | 22.4% | |
| 2017 | 6318 | 32.4% | |
| 2018 | 5833 | 29.9% | |
| 2019 | 2885 | 14.8% | |
| 2020 | 91 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2020 | 91 | 0.5% | |
| 2019 | 2885 | 14.8% | |
| 2018 | 5833 | 29.9% | |
| 2017 | 6318 | 32.4% | |
| 2016 | 4371 | 22.4% |
df_index
Numeric
| Distinct count | 16947 |
|---|---|
| Unique (%) | 86.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7531.25736 |
|---|---|
| Minimum | 0 |
| Maximum | 16946 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 487 |
| Q1 | 2437 |
| Median | 7197.5 |
| Q3 | 12071.75 |
| 95-th percentile | 15971.15 |
| Maximum | 16946 |
| Range | 16946 |
| Interquartile range | 9634.75 |
Descriptive statistics
| Standard deviation | 5173.606874 |
|---|---|
| Coef of variation | 0.6869512788 |
| Kurtosis | -1.290394422 |
| Mean | 7531.25736 |
| MAD | 4546.455735 |
| Skewness | 0.1887020453 |
| Sum | 146844456 |
| Variance | 26766208.09 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 2047 | 2 | < 0.1% | |
| 345 | 2 | < 0.1% | |
| 297 | 2 | < 0.1% | |
| 2360 | 2 | < 0.1% | |
| 313 | 2 | < 0.1% | |
| 2376 | 2 | < 0.1% | |
| 329 | 2 | < 0.1% | |
| 2392 | 2 | < 0.1% | |
| 2408 | 2 | < 0.1% | |
| 2472 | 2 | < 0.1% | |
| Other values (16937) | 19478 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2 | < 0.1% | |
| 1 | 2 | < 0.1% | |
| 2 | 2 | < 0.1% | |
| 3 | 2 | < 0.1% | |
| 4 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16946 | 1 | < 0.1% | |
| 16945 | 1 | < 0.1% | |
| 16944 | 1 | < 0.1% | |
| 16943 | 1 | < 0.1% | |
| 16942 | 1 | < 0.1% |
ID
Numeric
| Distinct count | 19498 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 17130.37342 |
|---|---|
| Minimum | 4854 |
| Maximum | 28773 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 4854 |
|---|---|
| 5-th percentile | 6094.85 |
| Q1 | 11227.25 |
| Median | 17276.5 |
| Q3 | 23191.75 |
| 95-th percentile | 27614.15 |
| Maximum | 28773 |
| Range | 23919 |
| Interquartile range | 11964.5 |
Descriptive statistics
| Standard deviation | 6912.570825 |
|---|---|
| Coef of variation | 0.4035271535 |
| Kurtosis | -1.20040614 |
| Mean | 17130.37342 |
| MAD | 5988.423385 |
| Skewness | -0.0587571619 |
| Sum | 334008021 |
| Variance | 47783635.42 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 6141 | 1 | < 0.1% | |
| 17117 | 1 | < 0.1% | |
| 21199 | 1 | < 0.1% | |
| 10960 | 1 | < 0.1% | |
| 15058 | 1 | < 0.1% | |
| 13011 | 1 | < 0.1% | |
| 6870 | 1 | < 0.1% | |
| 27352 | 1 | < 0.1% | |
| 25305 | 1 | < 0.1% | |
| 23262 | 1 | < 0.1% | |
| Other values (19488) | 19488 | 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 4854 | 1 | < 0.1% | |
| 4856 | 1 | < 0.1% | |
| 4858 | 1 | < 0.1% | |
| 4859 | 1 | < 0.1% | |
| 4860 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28773 | 1 | < 0.1% | |
| 28772 | 1 | < 0.1% | |
| 28771 | 1 | < 0.1% | |
| 28770 | 1 | < 0.1% | |
| 28769 | 1 | < 0.1% |
Last_Activity
Constant
This variable is constant and should be ignored for analysis
| Constant value | NaT |
|---|
Last_Modified_By
Categorical
| Distinct count | 63 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_47 | |
|---|---|
| Person_Name_50 | 1272 |
| Person_Name_13 | 760 |
| Other values (60) |
| Value | Count | Frequency (%) | |
| Person_Name_47 | 8519 | 43.7% | |
| Person_Name_50 | 1272 | 6.5% | |
| Person_Name_13 | 760 | 3.9% | |
| Person_Name_8 | 743 | 3.8% | |
| Person_Name_43 | 617 | 3.2% | |
| Person_Name_18 | 571 | 2.9% | |
| Person_Name_33 | 527 | 2.7% | |
| Person_Name_3 | 475 | 2.4% | |
| Person_Name_64 | 454 | 2.3% | |
| Person_Name_19 | 420 | 2.2% | |
| Other values (53) | 5140 | 26.4% |
| Max length | 14 |
|---|---|
| Mean length | 13.87885937 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Last_Modified_Date
Categorical
| Distinct count | 751 |
|---|---|
| Unique (%) | 3.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2/8/2018 | |
|---|---|
| 12/4/2016 | |
| 9/6/2018 | 257 |
| Other values (748) |
| Value | Count | Frequency (%) | |
| 2/8/2018 | 5821 | 29.9% | |
| 12/4/2016 | 2673 | 13.7% | |
| 9/6/2018 | 257 | 1.3% | |
| 9/26/2018 | 206 | 1.1% | |
| 6/9/2018 | 187 | 1.0% | |
| 2/22/2017 | 173 | 0.9% | |
| 4/15/2019 | 161 | 0.8% | |
| 4/12/2019 | 116 | 0.6% | |
| 1/21/2016 | 116 | 0.6% | |
| 4/4/2019 | 115 | 0.6% | |
| Other values (741) | 9673 | 49.6% |
| Max length | 10 |
|---|---|
| Mean length | 8.657246897 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Month
Categorical
| Distinct count | 60 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 2018 - 10 | 666 |
|---|---|
| 2017 - 6 | 643 |
| 2017 - 10 | 638 |
| Other values (57) |
| Value | Count | Frequency (%) | |
| 2018 - 10 | 666 | 3.4% | |
| 2017 - 6 | 643 | 3.3% | |
| 2017 - 10 | 638 | 3.3% | |
| 2016 - 3 | 628 | 3.2% | |
| 2017 - 7 | 625 | 3.2% | |
| 2017 - 5 | 586 | 3.0% | |
| 2018 - 4 | 579 | 3.0% | |
| 2019 - 4 | 575 | 2.9% | |
| 2017 - 12 | 574 | 2.9% | |
| 2018 - 6 | 542 | 2.8% | |
| Other values (50) | 13442 | 68.9% |
| Max length | 9 |
|---|---|
| Mean length | 8.225048723 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
Opportunity_Created_Date
Categorical
| Distinct count | 1203 |
|---|---|
| Unique (%) | 6.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 6/30/2017 | 124 |
|---|---|
| 1/22/2016 | 107 |
| 5/9/2017 | 104 |
| Other values (1200) |
| Value | Count | Frequency (%) | |
| 6/30/2017 | 124 | 0.6% | |
| 1/22/2016 | 107 | 0.5% | |
| 5/9/2017 | 104 | 0.5% | |
| 5/18/2016 | 99 | 0.5% | |
| 1/7/2016 | 89 | 0.5% | |
| 1/30/2018 | 87 | 0.4% | |
| 10/2/2017 | 86 | 0.4% | |
| 4/20/2017 | 83 | 0.4% | |
| 4/11/2019 | 83 | 0.4% | |
| 12/6/2017 | 82 | 0.4% | |
| Other values (1193) | 18554 | 95.2% |
| Max length | 10 |
|---|---|
| Mean length | 8.920196943 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Opportunity_ID
Numeric
| Distinct count | 11408 |
|---|---|
| Unique (%) | 58.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6148.946507 |
|---|---|
| Minimum | 0 |
| Maximum | 12803 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 523 |
| Q1 | 2892.25 |
| Median | 6173 |
| Q3 | 9072.75 |
| 95-th percentile | 12279.15 |
| Maximum | 12803 |
| Range | 12803 |
| Interquartile range | 6180.5 |
Descriptive statistics
| Standard deviation | 3745.879373 |
|---|---|
| Coef of variation | 0.609190431 |
| Kurtosis | -1.128057847 |
| Mean | 6148.946507 |
| MAD | 3194.806174 |
| Skewness | 0.1209435142 |
| Sum | 119892159 |
| Variance | 14031612.28 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 12460 | 36 | 0.2% | |
| 2008 | 36 | 0.2% | |
| 12266 | 26 | 0.1% | |
| 5123 | 26 | 0.1% | |
| 6606 | 26 | 0.1% | |
| 2911 | 24 | 0.1% | |
| 10973 | 24 | 0.1% | |
| 767 | 18 | 0.1% | |
| 11089 | 18 | 0.1% | |
| 6652 | 16 | 0.1% | |
| Other values (11398) | 19248 | 98.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 12803 | 1 | < 0.1% | |
| 12802 | 1 | < 0.1% | |
| 12801 | 3 | < 0.1% | |
| 12800 | 2 | < 0.1% | |
| 12799 | 1 | < 0.1% |
Opportunity_Name
Categorical
| Distinct count | 11408 |
|---|---|
| Unique (%) | 58.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Opportunity_Name_9795 | 36 |
|---|---|
| Opportunity_Name_5036 | 36 |
| Opportunity_Name_11461 | 26 |
| Other values (11405) |
| Value | Count | Frequency (%) | |
| Opportunity_Name_9795 | 36 | 0.2% | |
| Opportunity_Name_5036 | 36 | 0.2% | |
| Opportunity_Name_11461 | 26 | 0.1% | |
| Opportunity_Name_2922 | 26 | 0.1% | |
| Opportunity_Name_12179 | 26 | 0.1% | |
| Opportunity_Name_11879 | 24 | 0.1% | |
| Opportunity_Name_6835 | 24 | 0.1% | |
| Opportunity_Name_1661 | 18 | 0.1% | |
| Opportunity_Name_10033 | 18 | 0.1% | |
| Opportunity_Name_9628 | 16 | 0.1% | |
| Other values (11398) | 19248 | 98.7% |
| Max length | 22 |
|---|---|
| Mean length | 21.15647759 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Opportunity_Owner
Categorical
| Distinct count | 58 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Person_Name_50 | |
|---|---|
| Person_Name_8 | 1673 |
| Person_Name_13 | 1415 |
| Other values (55) |
| Value | Count | Frequency (%) | |
| Person_Name_50 | 3845 | 19.7% | |
| Person_Name_8 | 1673 | 8.6% | |
| Person_Name_13 | 1415 | 7.3% | |
| Person_Name_18 | 1119 | 5.7% | |
| Person_Name_43 | 937 | 4.8% | |
| Person_Name_3 | 922 | 4.7% | |
| Person_Name_64 | 771 | 4.0% | |
| Person_Name_4 | 763 | 3.9% | |
| Person_Name_32 | 740 | 3.8% | |
| Person_Name_19 | 615 | 3.2% | |
| Other values (48) | 6698 | 34.4% |
| Max length | 14 |
|---|---|
| Mean length | 13.80100523 |
| Min length | 13 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Opportunity_Type
Categorical
| Distinct count | 25 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Opportunity_Type_1 | |
|---|---|
| Opportunity_Type_7 | |
| Opportunity_Type_19 | |
| Other values (22) |
| Value | Count | Frequency (%) | |
| Opportunity_Type_1 | 7916 | 40.6% | |
| Opportunity_Type_7 | 6411 | 32.9% | |
| Opportunity_Type_19 | 2076 | 10.6% | |
| Opportunity_Type_8 | 1851 | 9.5% | |
| Opportunity_Type_3 | 341 | 1.7% | |
| Opportunity_Type_12 | 326 | 1.7% | |
| Opportunity_Type_20 | 194 | 1.0% | |
| Opportunity_Type_2 | 87 | 0.4% | |
| Opportunity_Type_4 | 63 | 0.3% | |
| Opportunity_Type_10 | 52 | 0.3% | |
| Other values (15) | 181 | 0.9% |
| Max length | 19 |
|---|---|
| Mean length | 18.14134783 |
| Min length | 18 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Planned_Delivery_End_Date
Categorical
| Distinct count | 1214 |
|---|---|
| Unique (%) | 6.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 3/31/2016 | 451 |
|---|---|
| 6/30/2017 | 322 |
| 2/29/2016 | 300 |
| Other values (1211) |
| Value | Count | Frequency (%) | |
| 3/31/2016 | 451 | 2.3% | |
| 6/30/2017 | 322 | 1.7% | |
| 2/29/2016 | 300 | 1.5% | |
| 9/28/2018 | 262 | 1.3% | |
| 6/29/2018 | 249 | 1.3% | |
| 6/30/2016 | 228 | 1.2% | |
| 9/30/2016 | 225 | 1.2% | |
| 12/31/2018 | 207 | 1.1% | |
| 3/31/2017 | 206 | 1.1% | |
| 12/31/2017 | 189 | 1.0% | |
| Other values (1204) | 16859 | 86.5% |
| Max length | 10 |
|---|---|
| Mean length | 9.041491435 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Planned_Delivery_Start_Date
Categorical
| Distinct count | 1193 |
|---|---|
| Unique (%) | 6.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 3/31/2016 | 381 |
|---|---|
| 2/29/2016 | 273 |
| 10/1/2018 | 211 |
| Other values (1190) |
| Value | Count | Frequency (%) | |
| 3/31/2016 | 381 | 2.0% | |
| 2/29/2016 | 273 | 1.4% | |
| 10/1/2018 | 211 | 1.1% | |
| 4/2/2018 | 207 | 1.1% | |
| 4/1/2019 | 186 | 1.0% | |
| 7/2/2018 | 169 | 0.9% | |
| 2/1/2018 | 150 | 0.8% | |
| 6/1/2018 | 146 | 0.7% | |
| 3/1/2018 | 139 | 0.7% | |
| 10/2/2017 | 128 | 0.7% | |
| Other values (1183) | 17508 | 89.8% |
| Max length | 10 |
|---|---|
| Mean length | 8.835572879 |
| Min length | 8 |
| Contains chars | False |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Price
Categorical
| Distinct count | 58 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 807 |
| 0.24 | 31 |
| Other values (55) | 485 |
| Value | Count | Frequency (%) | |
| None | 18175 | 93.2% | |
| Other | 807 | 4.1% | |
| 0.24 | 31 | 0.2% | |
| 0.28 | 28 | 0.1% | |
| 0.27 | 24 | 0.1% | |
| 0.37 | 24 | 0.1% | |
| 0.41 | 24 | 0.1% | |
| 0.29 | 24 | 0.1% | |
| 0.32 | 21 | 0.1% | |
| 0.26 | 21 | 0.1% | |
| Other values (48) | 319 | 1.6% |
| Max length | 5 |
|---|---|
| Mean length | 4.045543133 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Pricing,_Delivery_Terms_Approved
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 11241 | 57.7% | |
| 0 | 8257 | 42.3% |
Pricing,_Delivery_Terms_Quote_Appr
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 15415 | 79.1% | |
| 0 | 4083 | 20.9% |
Prod_Category_A
Constant
This variable is constant and should be ignored for analysis
| Constant value | Prod_Category_A_None |
|---|
Product_Category_B
Categorical
| Distinct count | 29 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 700 |
| Product_Category_B_7 | 64 |
| Other values (26) | 616 |
| Value | Count | Frequency (%) | |
| None | 18118 | 92.9% | |
| Other | 700 | 3.6% | |
| Product_Category_B_7 | 64 | 0.3% | |
| Product_Category_B_2 | 62 | 0.3% | |
| Product_Category_B_11 | 57 | 0.3% | |
| Product_Category_B_12 | 53 | 0.3% | |
| Product_Category_B_5 | 48 | 0.2% | |
| Product_Category_B_4 | 48 | 0.2% | |
| Product_Category_B_24 | 33 | 0.2% | |
| Product_Category_B_3 | 31 | 0.2% | |
| Other values (19) | 284 | 1.5% |
| Max length | 21 |
|---|---|
| Mean length | 4.610780593 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Family
Categorical
| Distinct count | 247 |
|---|---|
| Unique (%) | 1.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Product_Family_133 | 1438 |
|---|---|
| Product_Family_77 | 1345 |
| Product_Family_132 | 894 |
| Other values (244) |
| Value | Count | Frequency (%) | |
| Product_Family_133 | 1438 | 7.4% | |
| Product_Family_77 | 1345 | 6.9% | |
| Product_Family_132 | 894 | 4.6% | |
| Product_Family_212 | 710 | 3.6% | |
| Product_Family_100 | 630 | 3.2% | |
| Product_Family_140 | 627 | 3.2% | |
| Product_Family_85 | 598 | 3.1% | |
| Product_Family_115 | 541 | 2.8% | |
| Product_Family_226 | 524 | 2.7% | |
| Product_Family_208 | 509 | 2.6% | |
| Other values (237) | 11682 | 59.9% |
| Max length | 18 |
|---|---|
| Mean length | 17.68622423 |
| Min length | 16 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Name
Categorical
| Distinct count | 506 |
|---|---|
| Unique (%) | 2.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Product_Name_100 | 976 |
|---|---|
| Product_Name_226 | 950 |
| Product_Name_231 | 670 |
| Other values (503) |
| Value | Count | Frequency (%) | |
| Product_Name_100 | 976 | 5.0% | |
| Product_Name_226 | 950 | 4.9% | |
| Product_Name_231 | 670 | 3.4% | |
| Product_Name_491 | 524 | 2.7% | |
| Product_Name_241 | 518 | 2.7% | |
| Product_Name_4 | 474 | 2.4% | |
| Product_Name_192 | 443 | 2.3% | |
| Product_Name_132 | 394 | 2.0% | |
| Product_Name_111 | 390 | 2.0% | |
| Product_Name_29 | 389 | 2.0% | |
| Other values (496) | 13770 | 70.6% |
| Max length | 16 |
|---|---|
| Mean length | 15.77546415 |
| Min length | 14 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Product_Type
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Other | 673 |
| Product_Type_1 | 255 |
| Other values (4) | 448 |
| Value | Count | Frequency (%) | |
| None | 18122 | 92.9% | |
| Other | 673 | 3.5% | |
| Product_Type_1 | 255 | 1.3% | |
| Product_Type_3 | 204 | 1.0% | |
| Product_Type_0 | 122 | 0.6% | |
| Product_Type_4 | 107 | 0.5% | |
| Product_Type_2 | 15 | 0.1% |
| Max length | 14 |
|---|---|
| Mean length | 4.395066161 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Quote_Expiry_Date
Categorical
| Distinct count | 1124 |
|---|---|
| Unique (%) | 5.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| NaT | |
|---|---|
| 6/30/2017 | 436 |
| 3/31/2017 | 363 |
| Other values (1121) |
| Value | Count | Frequency (%) | |
| NaT | 5861 | 30.1% | |
| 6/30/2017 | 436 | 2.2% | |
| 3/31/2017 | 363 | 1.9% | |
| 9/30/2017 | 225 | 1.2% | |
| 12/31/2016 | 200 | 1.0% | |
| 10/31/2017 | 171 | 0.9% | |
| 1/31/2018 | 163 | 0.8% | |
| 11/30/2017 | 156 | 0.8% | |
| 12/31/2017 | 156 | 0.8% | |
| 5/31/2017 | 153 | 0.8% | |
| Other values (1114) | 11614 | 59.6% |
| Max length | 10 |
|---|---|
| Mean length | 7.250538517 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Quote_Type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Non Binding | |
|---|---|
| Binding | 170 |
| Value | Count | Frequency (%) | |
| Non Binding | 19328 | 99.1% | |
| Binding | 170 | 0.9% |
| Max length | 11 |
|---|---|
| Mean length | 10.96512463 |
| Min length | 7 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Region
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| EMEA | |
|---|---|
| Japan | |
| Americas | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| EMEA | 5502 | 28.2% | |
| Japan | 5093 | 26.1% | |
| Americas | 4961 | 25.4% | |
| APAC | 3744 | 19.2% | |
| Middle East | 198 | 1.0% |
| Max length | 11 |
|---|---|
| Mean length | 5.350035901 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Sales_Contract_No
Categorical
| Distinct count | 6065 |
|---|---|
| Unique (%) | 31.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| 479 | 36 |
| 108 | 36 |
| Other values (6062) |
| Value | Count | Frequency (%) | |
| None | 8186 | 42.0% | |
| 479 | 36 | 0.2% | |
| 108 | 36 | 0.2% | |
| 5849 | 24 | 0.1% | |
| 2575 | 18 | 0.1% | |
| 3123 | 16 | 0.1% | |
| 3878 | 16 | 0.1% | |
| 3876 | 16 | 0.1% | |
| 3877 | 16 | 0.1% | |
| 3980 | 16 | 0.1% | |
| Other values (6055) | 11118 | 57.0% |
| Max length | 4 |
|---|---|
| Mean length | 3.891681198 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Size
Categorical
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Size_3 | 531 |
| Other | 478 |
| Other values (4) | 332 |
| Value | Count | Frequency (%) | |
| None | 18157 | 93.1% | |
| Size_3 | 531 | 2.7% | |
| Other | 478 | 2.5% | |
| Size_4 | 283 | 1.5% | |
| Size_1 | 30 | 0.2% | |
| Size_0 | 17 | 0.1% | |
| Size_2 | 2 | < 0.1% |
| Max length | 6 |
|---|---|
| Mean length | 4.113037235 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Source_
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| Source_7 | |
| Source_9 | 1771 |
| Other values (11) |
| Value | Count | Frequency (%) | |
| None | 10612 | 54.4% | |
| Source_7 | 3666 | 18.8% | |
| Source_9 | 1771 | 9.1% | |
| Source_11 | 1625 | 8.3% | |
| Source_13 | 911 | 4.7% | |
| Source_3 | 458 | 2.3% | |
| Source_1 | 148 | 0.8% | |
| Source_10 | 127 | 0.7% | |
| Source_2 | 99 | 0.5% | |
| Source_4 | 45 | 0.2% | |
| Other values (4) | 36 | 0.2% |
| Max length | 9 |
|---|---|
| Mean length | 5.959636886 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
Stage
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.3% |
| Missing (n) | 64 |
| 1 | |
|---|---|
| 0 | |
| -1 | |
| (Missing) | 64 |
| Value | Count | Frequency (%) | |
| 1 | 9533 | 48.9% | |
| 0 | 7350 | 37.7% | |
| -1 | 2551 | 13.1% | |
| (Missing) | 64 | 0.3% |
| Max length | 4 |
|---|---|
| Mean length | 3.130833932 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | True |
Submitted_for_Approval
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 0 | |
|---|---|
| 1 | 14 |
| Value | Count | Frequency (%) | |
| 0 | 19484 | 99.9% | |
| 1 | 14 | 0.1% |
Territory
Categorical
| Distinct count | 79 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| None | |
|---|---|
| NW America | 1995 |
| Germany | 1955 |
| Other values (76) |
| Value | Count | Frequency (%) | |
| None | 5180 | 26.6% | |
| NW America | 1995 | 10.2% | |
| Germany | 1955 | 10.0% | |
| Australia | 1416 | 7.3% | |
| NE America | 939 | 4.8% | |
| India | 915 | 4.7% | |
| Japan | 766 | 3.9% | |
| Netherlands | 629 | 3.2% | |
| SE America | 601 | 3.1% | |
| France | 584 | 3.0% | |
| Other values (69) | 4518 | 23.2% |
| Max length | 20 |
|---|---|
| Mean length | 7.170427736 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
Total_Amount
Numeric
| Distinct count | 10246 |
|---|---|
| Unique (%) | 52.5% |
| Missing (%) | 0.3% |
| Missing (n) | 59 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1969405.111 |
|---|---|
| Minimum | 0 |
| Maximum | 1320000000 |
| Zeros (%) | 0.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2963.22 |
| Q1 | 29925 |
| Median | 107590 |
| Q3 | 431585.6 |
| 95-th percentile | 6720481.026 |
| Maximum | 1320000000 |
| Range | 1320000000 |
| Interquartile range | 401660.6 |
Descriptive statistics
| Standard deviation | 18108757.87 |
|---|---|
| Coef of variation | 9.195039538 |
| Kurtosis | 2236.42959 |
| Mean | 1969405.111 |
| MAD | 3069151.633 |
| Skewness | 40.71457842 |
| Sum | 3.828326596e+10 |
| Variance | 3.279271115e+14 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 6200 | 513 | 2.6% | |
| 4400 | 461 | 2.4% | |
| 18000 | 356 | 1.8% | |
| 140000 | 272 | 1.4% | |
| 1600 | 204 | 1.0% | |
| 160000 | 132 | 0.7% | |
| 109620 | 100 | 0.5% | |
| 23400 | 80 | 0.4% | |
| 85260 | 75 | 0.4% | |
| 81200 | 75 | 0.4% | |
| Other values (10235) | 17171 | 88.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 52 | 0.3% | |
| 0.01 | 7 | < 0.1% | |
| 0.02 | 3 | < 0.1% | |
| 0.04 | 1 | < 0.1% | |
| 0.1 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1320000000 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% | |
| 660004620 | 1 | < 0.1% |
Total_Amount_Currency
Recoded
This variable is a recoding of ASP_Currency and should be ignored for analysis
Total_Taxable_Amount
Numeric
| Distinct count | 8268 |
|---|---|
| Unique (%) | 42.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3246258.588 |
|---|---|
| Minimum | 0 |
| Maximum | 1356338620 |
| Zeros (%) | 5.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 84000 |
| Median | 356475 |
| Q3 | 1010300 |
| 95-th percentile | 12643366.05 |
| Maximum | 1356338620 |
| Range | 1356338620 |
| Interquartile range | 926300 |
Descriptive statistics
| Standard deviation | 20870305.74 |
|---|---|
| Coef of variation | 6.429033661 |
| Kurtosis | 1437.812404 |
| Mean | 3246258.588 |
| MAD | 4829295.512 |
| Skewness | 30.86984245 |
| Sum | 6.329554995e+10 |
| Variance | 4.355696616e+14 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 1090 | 5.6% | |
| 588325 | 72 | 0.4% | |
| 109620 | 68 | 0.3% | |
| 488700 | 66 | 0.3% | |
| 413700 | 60 | 0.3% | |
| 552400 | 60 | 0.3% | |
| 1767640 | 48 | 0.2% | |
| 523100 | 40 | 0.2% | |
| 105840 | 37 | 0.2% | |
| 148331.25 | 36 | 0.2% | |
| Other values (8258) | 17921 | 91.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1090 | 5.6% | |
| 0.15 | 1 | < 0.1% | |
| 45 | 1 | < 0.1% | |
| 78.18 | 1 | < 0.1% | |
| 100.1 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1356338620 | 1 | < 0.1% | |
| 919992410 | 1 | < 0.1% | |
| 760000000 | 1 | < 0.1% | |
| 680872500 | 1 | < 0.1% | |
| 660005280 | 1 | < 0.1% |
Total_Taxable_Amount_Currency
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| USD | |
|---|---|
| EUR | |
| JPY | |
| Other values (2) | 557 |
| Value | Count | Frequency (%) | |
| USD | 8891 | 45.6% | |
| EUR | 5354 | 27.5% | |
| JPY | 4696 | 24.1% | |
| AUD | 553 | 2.8% | |
| GBP | 4 | < 0.1% |
| Max length | 3 |
|---|---|
| Mean length | 3 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
TRF
Numeric
| Distinct count | 107 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.354959483 |
|---|---|
| Minimum | 0 |
| Maximum | 1272 |
| Zeros (%) | 70.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 1 |
| 95-th percentile | 10 |
| Maximum | 1272 |
| Range | 1272 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 15.45445392 |
|---|---|
| Coef of variation | 6.562513721 |
| Kurtosis | 2560.05356 |
| Mean | 2.354959483 |
| MAD | 3.703936548 |
| Skewness | 38.14278497 |
| Sum | 45917 |
| Variance | 238.8401459 |
| Memory size | 152.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 13677 | 70.1% | |
| 1 | 2688 | 13.8% | |
| 2 | 729 | 3.7% | |
| 3 | 397 | 2.0% | |
| 5 | 330 | 1.7% | |
| 4 | 244 | 1.3% | |
| 10 | 201 | 1.0% | |
| 6 | 148 | 0.8% | |
| 7 | 116 | 0.6% | |
| 20 | 89 | 0.5% | |
| Other values (97) | 879 | 4.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 13677 | 70.1% | |
| 1 | 2688 | 13.8% | |
| 2 | 729 | 3.7% | |
| 3 | 397 | 2.0% | |
| 4 | 244 | 1.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1272 | 1 | < 0.1% | |
| 502 | 1 | < 0.1% | |
| 500 | 1 | < 0.1% | |
| 429 | 1 | < 0.1% | |
| 400 | 2 | < 0.1% |
First rows
| Account_Created_Date | Account_Name | Account_Owner | Account_Type | Actual_Delivery_Date | ASP | ASP_(converted) | ASP_(converted)_Currency | ASP_Currency | Billing_Country | Brand | Bureaucratic_Code | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Currency | Delivery_Quarter | Delivery_Terms | Delivery_Year | df_index | ID | Last_Activity | Last_Modified_By | Last_Modified_Date | Month | Opportunity_Created_Date | Opportunity_ID | Opportunity_Name | Opportunity_Owner | Opportunity_Type | Planned_Delivery_End_Date | Planned_Delivery_Start_Date | Price | Pricing,_Delivery_Terms_Approved | Pricing,_Delivery_Terms_Quote_Appr | Prod_Category_A | Product_Category_B | Product_Family | Product_Name | Product_Type | Quote_Expiry_Date | Quote_Type | Region | Sales_Contract_No | Size | Source_ | Stage | Submitted_for_Approval | Territory | Total_Amount | Total_Amount_Currency | Total_Taxable_Amount | Total_Taxable_Amount_Currency | TRF | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 6/16/2015 | Account_Name_619 | Person_Name_51 | Account_Type_2 | NaT | 0.52 | 0.58817 | USD | EUR | Netherlands | None | Bureaucratic_Code_4 | 1 | 1 | None | Q2 | Delivery_Terms_2 | 2016 | 0 | 27761 | NaT | Person_Name_18 | 6/13/2016 | 2016 - 5 | 12/7/2015 | 0 | Opportunity_Name_12598 | Person_Name_18 | Opportunity_Type_1 | 6/30/2016 | 5/1/2016 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_77 | Product_Name_99 | None | 1/30/2016 | Non Binding | EMEA | None | None | None | 0.0 | 0 | None | 5272800.0 | EUR | 5272800.0 | EUR | 10 |
| 1 | 6/16/2015 | Account_Name_619 | Person_Name_51 | Account_Type_2 | NaT | 0.53 | 0.59948 | USD | EUR | Netherlands | None | Bureaucratic_Code_4 | 0 | 0 | None | Q1 | Delivery_Terms_2 | 2016 | 1 | 27760 | NaT | Person_Name_20 | 1/15/2016 | 2016 - 1 | 12/7/2015 | 1 | Opportunity_Name_12600 | Person_Name_20 | Opportunity_Type_1 | 1/20/2016 | 1/18/2016 | None | 0 | 0 | Prod_Category_A_None | None | Product_Family_77 | Product_Name_100 | None | 1/20/2016 | Non Binding | EMEA | 39 | None | None | 1.0 | 0 | None | 48230.0 | EUR | 48230.0 | EUR | 0 |
| 2 | 4/21/2015 | Account_Name_1794 | Person_Name_64 | Account_Type_5 | NaT | 0.48 | 0.48000 | USD | USD | United States | None | Bureaucratic_Code_4 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 2 | 27446 | NaT | Person_Name_8 | 9/29/2016 | 2016 - 1 | 12/8/2015 | 2 | Opportunity_Name_469 | Person_Name_8 | Opportunity_Type_1 | 1/25/2016 | 1/25/2016 | None | 0 | 0 | Prod_Category_A_None | None | Product_Family_81 | Product_Name_91 | None | 9/30/2016 | Non Binding | Americas | 760 | None | Source_7 | 1.0 | 0 | NW America | 83865.6 | USD | 83865.6 | USD | 0 |
| 3 | 7/27/2013 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | NaT | 0.53 | 0.53000 | USD | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 3 | 16808 | NaT | Person_Name_8 | 3/27/2018 | 2018 - 2 | 12/8/2015 | 3 | Opportunity_Name_415 | Person_Name_8 | Opportunity_Type_19 | 3/31/2018 | 2/1/2018 | 0.42 | 0 | 1 | Prod_Category_A_None | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | NaT | Non Binding | Americas | None | Size_4 | Source_11 | 0.0 | 0 | NW America | 7421881.5 | USD | 7421881.5 | USD | 14 |
| 4 | 7/27/2013 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | NaT | 0.53 | 0.53000 | USD | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 4 | 16805 | NaT | Person_Name_8 | 3/27/2018 | 2018 - 2 | 12/8/2015 | 4 | Opportunity_Name_851 | Person_Name_8 | Opportunity_Type_19 | 2/28/2018 | 2/1/2018 | 0.42 | 0 | 1 | Prod_Category_A_None | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | 6/2/2017 | Non Binding | Americas | None | Size_4 | Source_11 | 0.0 | 0 | NW America | 13357192.5 | USD | 13357192.5 | USD | 25 |
| 5 | 7/27/2013 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | NaT | 0.53 | 0.53000 | USD | USD | United States | Other | Bureaucratic_Code_5 | 1 | 0 | USD | Q1 | Delivery_Terms_1 | 2018 | 5 | 16802 | NaT | Person_Name_8 | 3/27/2018 | 2018 - 2 | 12/8/2015 | 5 | Opportunity_Name_939 | Person_Name_8 | Opportunity_Type_19 | 3/31/2018 | 2/1/2018 | 0.42 | 0 | 1 | Prod_Category_A_None | Product_Category_B_16 | Product_Family_209 | Product_Name_432 | Product_Type_0 | 6/2/2017 | Non Binding | Americas | None | Size_4 | Source_11 | 0.0 | 0 | NW America | 14838277.5 | USD | 14838277.5 | USD | 28 |
| 6 | 7/27/2013 | Account_Name_1201 | Person_Name_8 | Account_Type_5 | NaT | 0.38 | 0.38000 | USD | USD | United States | None | Bureaucratic_Code_5 | 1 | 0 | None | Q1 | Delivery_Terms_4 | 2017 | 6 | 16799 | NaT | Person_Name_8 | 10/7/2016 | 2017 - 2 | 12/8/2015 | 6 | Opportunity_Name_1618 | Person_Name_8 | Opportunity_Type_19 | 5/1/2017 | 2/1/2017 | None | 0 | 1 | Prod_Category_A_None | None | Product_Family_164 | Product_Name_308 | None | NaT | Non Binding | Americas | None | None | Source_11 | 0.0 | 0 | NW America | 2659494.6 | USD | 2659494.6 | USD | 7 |
| 7 | 4/21/2015 | Account_Name_1794 | Person_Name_64 | Account_Type_5 | NaT | 0.48 | 0.48000 | USD | USD | United States | None | Bureaucratic_Code_4 | 1 | 1 | None | Q1 | Delivery_Terms_4 | 2016 | 7 | 27455 | NaT | Person_Name_8 | 12/9/2015 | 2016 - 1 | 12/9/2015 | 7 | Opportunity_Name_8227 | Person_Name_8 | Opportunity_Type_1 | 1/25/2016 | 1/25/2016 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_143 | Product_Name_251 | None | 1/7/2016 | Non Binding | Americas | None | None | Source_7 | 1.0 | 0 | NW America | 50688.0 | USD | 50688.0 | USD | 0 |
| 8 | 4/20/2015 | Account_Name_1888 | Person_Name_50 | Account_Type_2 | NaT | NaN | NaN | USD | JPY | Japan | None | Bureaucratic_Code_5 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 8 | 24353 | NaT | Person_Name_50 | 4/5/2016 | 2016 - 2 | 12/9/2015 | 8 | Opportunity_Name_6151 | Person_Name_50 | Opportunity_Type_7 | 2/29/2016 | 2/29/2016 | None | 0 | 1 | Prod_Category_A_None | None | Product_Family_6 | Product_Name_6 | None | NaT | Non Binding | Japan | None | None | None | 0.0 | 0 | None | 15600.0 | JPY | 470400.0 | JPY | 0 |
| 9 | 4/20/2015 | Account_Name_1888 | Person_Name_50 | Account_Type_2 | NaT | NaN | NaN | USD | JPY | Japan | None | Bureaucratic_Code_5 | 0 | 0 | None | Q1 | Delivery_Terms_4 | 2016 | 9 | 24355 | NaT | Person_Name_50 | 4/5/2016 | 2016 - 2 | 12/9/2015 | 8 | Opportunity_Name_6151 | Person_Name_50 | Opportunity_Type_7 | 2/29/2016 | 2/29/2016 | None | 0 | 1 | Prod_Category_A_None | None | Product_Family_4 | Product_Name_4 | None | NaT | Non Binding | Japan | None | None | None | 0.0 | 0 | None | 4400.0 | JPY | 470400.0 | JPY | 0 |
Last rows
| Account_Created_Date | Account_Name | Account_Owner | Account_Type | Actual_Delivery_Date | ASP | ASP_(converted) | ASP_(converted)_Currency | ASP_Currency | Billing_Country | Brand | Bureaucratic_Code | Bureaucratic_Code_0_Approval | Bureaucratic_Code_0_Approved | Currency | Delivery_Quarter | Delivery_Terms | Delivery_Year | df_index | ID | Last_Activity | Last_Modified_By | Last_Modified_Date | Month | Opportunity_Created_Date | Opportunity_ID | Opportunity_Name | Opportunity_Owner | Opportunity_Type | Planned_Delivery_End_Date | Planned_Delivery_Start_Date | Price | Pricing,_Delivery_Terms_Approved | Pricing,_Delivery_Terms_Quote_Appr | Prod_Category_A | Product_Category_B | Product_Family | Product_Name | Product_Type | Quote_Expiry_Date | Quote_Type | Region | Sales_Contract_No | Size | Source_ | Stage | Submitted_for_Approval | Territory | Total_Amount | Total_Amount_Currency | Total_Taxable_Amount | Total_Taxable_Amount_Currency | TRF | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19488 | 4/19/2018 | Account_Name_1379 | Person_Name_13 | Account_Type_0 | NaT | 0.27 | 0.30540 | USD | EUR | Norway | None | Bureaucratic_Code_2 | 1 | 0 | None | Q2 | Delivery_Terms_7 | 2019 | 2541 | 14091 | NaT | Person_Name_13 | 4/25/2019 | 2019 - 5 | 4/25/2019 | 12360 | Opportunity_Name_9792 | Person_Name_13 | Opportunity_Type_7 | 5/17/2019 | 5/13/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_140 | Product_Name_241 | None | NaT | Non Binding | EMEA | None | None | Source_9 | -1.0 | 1 | Norway | 28992.6 | EUR | 74834.55 | EUR | 0 |
| 19489 | 6/30/2017 | Account_Name_1542 | Person_Name_50 | Account_Type_5 | NaT | 44.00 | 0.39558 | USD | JPY | Japan | None | Bureaucratic_Code_4 | 0 | 0 | None | Q3 | Delivery_Terms_4 | 2019 | 2542 | 5817 | NaT | Person_Name_1 | 4/26/2019 | 2019 - 7 | 4/26/2019 | 12361 | Opportunity_Name_7265 | Person_Name_55 | Opportunity_Type_1 | 7/1/2019 | 7/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_168 | Product_Name_322 | None | NaT | Non Binding | Japan | None | None | None | -1.0 | 0 | Japan | 5068800.0 | JPY | 5068800.00 | JPY | 0 |
| 19490 | 2/12/2019 | Account_Name_1377 | Person_Name_55 | Account_Type_0 | NaT | 38.00 | 0.34163 | USD | JPY | Japan | None | Bureaucratic_Code_4 | 0 | 0 | None | Q4 | Delivery_Terms_4 | 2019 | 2543 | 11318 | NaT | Person_Name_55 | 4/26/2019 | 2019 - 10 | 4/26/2019 | 12362 | Opportunity_Name_11565 | Person_Name_55 | Opportunity_Type_1 | 10/1/2019 | 10/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_154 | Product_Name_276 | None | NaT | Non Binding | Japan | 6506 | None | None | -1.0 | 0 | None | 20282500.0 | JPY | 20282500.00 | JPY | 1 |
| 19491 | 6/17/2015 | Account_Name_628 | Person_Name_18 | Account_Type_2 | NaT | 0.30 | 0.33933 | USD | EUR | Belgium | None | Bureaucratic_Code_4 | 1 | 1 | None | Q3 | Delivery_Terms_2 | 2019 | 2544 | 27867 | NaT | Person_Name_23 | 4/26/2019 | 2019 - 7 | 4/26/2019 | 12363 | Opportunity_Name_4638 | Person_Name_18 | Opportunity_Type_1 | 7/19/2019 | 7/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_160 | Product_Name_290 | None | 5/24/2019 | Non Binding | EMEA | None | None | Source_7 | -1.0 | 0 | Belgium | 227292.0 | EUR | 227292.00 | EUR | 1 |
| 19492 | 6/12/2017 | Account_Name_1686 | Person_Name_13 | Account_Type_0 | NaT | 0.30 | 0.30000 | USD | USD | South Africa | None | Bureaucratic_Code_4 | 0 | 0 | None | Q2 | Delivery_Terms_7 | 2019 | 2545 | 16339 | NaT | Person_Name_13 | 4/26/2019 | 2019 - 5 | 4/26/2019 | 12364 | Opportunity_Name_11120 | Person_Name_13 | Opportunity_Type_1 | 5/10/2019 | 5/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_140 | Product_Name_241 | None | 5/24/2019 | Non Binding | EMEA | 6508 | None | Source_3 | -1.0 | 0 | KSA | 23010.0 | USD | 147750.00 | USD | 0 |
| 19493 | 6/12/2017 | Account_Name_1686 | Person_Name_13 | Account_Type_0 | NaT | 0.30 | 0.30000 | USD | USD | South Africa | None | Bureaucratic_Code_4 | 0 | 0 | None | Q2 | Delivery_Terms_7 | 2019 | 2546 | 16345 | NaT | Person_Name_13 | 4/26/2019 | 2019 - 5 | 4/26/2019 | 12364 | Opportunity_Name_11120 | Person_Name_13 | Opportunity_Type_1 | 5/10/2019 | 5/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_213 | Product_Name_447 | None | 5/24/2019 | Non Binding | EMEA | 6508 | None | Source_3 | -1.0 | 0 | KSA | 124740.0 | USD | 147750.00 | USD | 0 |
| 19494 | 6/8/2018 | Account_Name_768 | Person_Name_38 | Account_Type_2 | NaT | 0.41 | 0.41000 | USD | USD | United States | None | Bureaucratic_Code_4 | 0 | 0 | None | Q4 | Delivery_Terms_4 | 2019 | 2547 | 15218 | NaT | Person_Name_38 | 4/27/2019 | 2019 - 10 | 4/26/2019 | 12365 | Opportunity_Name_9694 | Person_Name_38 | Opportunity_Type_1 | 12/31/2019 | 10/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_221 | Product_Name_477 | None | 5/24/2019 | Non Binding | Americas | 6510 | None | None | -1.0 | 0 | SE America | 45054.9 | USD | 45054.90 | USD | 0 |
| 19495 | 6/8/2018 | Account_Name_768 | Person_Name_38 | Account_Type_2 | NaT | 0.41 | 0.41000 | USD | USD | United States | None | Bureaucratic_Code_4 | 1 | 1 | None | Q4 | Delivery_Terms_4 | 2019 | 2548 | 15224 | NaT | Person_Name_38 | 4/27/2019 | 2019 - 10 | 4/26/2019 | 12366 | Opportunity_Name_9693 | Person_Name_38 | Opportunity_Type_1 | 12/31/2019 | 10/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_221 | Product_Name_477 | None | 5/24/2019 | Non Binding | Americas | 6511 | None | None | -1.0 | 0 | SE America | 100122.0 | USD | 100122.00 | USD | 0 |
| 19496 | 8/29/2018 | Account_Name_1635 | Person_Name_9 | Account_Type_2 | NaT | 0.50 | 0.50000 | USD | USD | United States | None | Bureaucratic_Code_4 | 0 | 0 | None | Q3 | Delivery_Terms_4 | 2019 | 2549 | 7286 | NaT | Person_Name_9 | 4/26/2019 | 2019 - 8 | 4/26/2019 | 12367 | Opportunity_Name_1676 | Person_Name_9 | Opportunity_Type_7 | 8/1/2019 | 8/1/2019 | None | 1 | 1 | Prod_Category_A_None | None | Product_Family_156 | Product_Name_281 | None | 5/26/2019 | Non Binding | Americas | None | None | None | -1.0 | 0 | NE America | 143220.0 | USD | 143220.00 | USD | 0 |
| 19497 | 3/3/2016 | Account_Name_271 | Person_Name_18 | Account_Type_0 | NaT | 0.29 | 0.32802 | USD | EUR | Luxembourg | None | Bureaucratic_Code_5 | 0 | 0 | None | Q4 | Delivery_Terms_2 | 2019 | 2550 | 11263 | NaT | Person_Name_16 | 4/27/2019 | 2019 - 10 | 4/27/2019 | 12368 | Opportunity_Name_3187 | Person_Name_16 | Opportunity_Type_1 | 12/13/2019 | 10/21/2019 | None | 0 | 1 | Prod_Category_A_None | None | Product_Family_171 | Product_Name_331 | None | 2/8/2019 | Non Binding | EMEA | None | None | None | -1.0 | 0 | Belgium | 871020.8 | EUR | 871020.80 | EUR | 3 |